﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="allxinxi.aspx.cs" Inherits="Grade.WebForm4" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">

    .auto-style1 {
        width: 701px;
        height: 386px;
        border: 1px solid #c0c0c0;
    }
    .auto-style2 {
        text-align: center;
        font-size: x-large;
    }
    .auto-style3 {
        text-align: center;
        width: 225px;
    }
    .auto-style12 {
        text-align: center;
        width: 225px;
        height: 52px;
    }
    .auto-style15 {
        text-align: center;
        width: 225px;
        height: 66px;
    }
    .auto-style14 {
        height: 66px;
        width: 565px;
    }
    .auto-style16 {
        width: 565px;
    }
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <table align="center" class="auto-style1" border="0">
    <tr>
        <td class="auto-style2" colspan="2" rowspan="1"><strong style="text-align: left">学生基本信息查询</strong></td>
    </tr>
    <tr>
        <td class="auto-style3" rowspan="1">
            <asp:Button ID="btnselect0" runat="server" Text="查询信息" PostBackUrl="~/select.aspx" />
        </td>
        <td class="auto-style16">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="btnjs1" runat="server" Text="查询全部信息" />
        </td>
    </tr>
    <tr>
        <td class="auto-style3" rowspan="1">
            <asp:Button ID="btnupdate0" runat="server" Text="更新信息" PostBackUrl="~/updata.aspx" />
        </td>
        <td rowspan="3" class="auto-style16">
            <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataKeyNames="No" DataSourceID="SqlDataSource2">
                <Columns>
                    <asp:BoundField DataField="No" HeaderText="No" ReadOnly="True" SortExpression="No" />
                    <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                    <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                    <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                    <asp:BoundField DataField="Major" HeaderText="Major" SortExpression="Major" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112118ConnectionString3 %>" SelectCommand="SELECT * FROM [Student]"></asp:SqlDataSource>
            <br /></td>
    </tr>
    <tr>
        <td class="auto-style3" rowspan="1">
            <asp:Button ID="btninsert0" runat="server" PostBackUrl="~/insert.aspx" Text="增加信息" />
        </td>
    </tr>
    <tr>
        <td class="auto-style12" rowspan="1">
            <asp:Button ID="btndelete0" runat="server" Text="删除信息" PostBackUrl="~/delect.aspx" />
        </td>
    </tr>
    <tr>
        <td class="auto-style15" rowspan="1"></td>
        <td class="auto-style14" rowspan="1"></td>
    </tr>
</table>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <table align="center" class="auto-style1">
    <tr>
        <td class="auto-style2" colspan="2" rowspan="1"><strong style="text-align: left">学生基本信息查询</strong></td>
    </tr>
    <tr>
        <td class="auto-style3" rowspan="1">
            <asp:Button ID="btnselect" runat="server" Text="查询信息" PostBackUrl="~/select.aspx" />
        </td>
        <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="btnjs0" runat="server" Text="查询全部信息" />
        </td>
    </tr>
    <tr>
        <td class="auto-style3" rowspan="1">
            <asp:Button ID="btnupdate" runat="server" Text="更新信息" />
        </td>
        <td rowspan="3">
            <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="No" DataSourceID="SqlDataSource1">
                <Columns>
                    <asp:BoundField DataField="No" HeaderText="No" ReadOnly="True" SortExpression="No" />
                    <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                    <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                    <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                    <asp:BoundField DataField="Major" HeaderText="Major" SortExpression="Major" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112118ConnectionString3 %>" SelectCommand="SELECT * FROM [Student]"></asp:SqlDataSource>
            <br />
        </td>
    </tr>
    <tr>
        <td class="auto-style3" rowspan="1">
            <asp:Button ID="btninsert" runat="server" PostBackUrl="~/insert.aspx" Text="增加信息" />
        </td>
    </tr>
    <tr>
        <td class="auto-style12" rowspan="1">
            <asp:Button ID="btndelete" runat="server" Text="删除信息" />
        </td>
    </tr>
    <tr>
        <td class="auto-style15" rowspan="1"></td>
        <td class="auto-style14" rowspan="1"></td>
    </tr>
</table>
</asp:Content>
